package com.kmust.dream.wanderingdream.donation.dao;

import com.kmust.dream.wanderingdream.donation.entity.LearningstatusInformationDonationEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 
 * 
 * @author Leng
 * @email Leng81605@gmail.com
 * @date 2021-07-12 21:35:52
 */
@Mapper
public interface LearningstatusInformationDonationDao extends BaseMapper<LearningstatusInformationDonationEntity> {
	@Select("SELECT LSID,recipient_id,examination_name,examination_time,examination_results,class_ranking,status FROM `learningstatus_information_donation` WHERE recipient_id = #{recipientId}")
	List<LearningstatusInformationDonationEntity> getList(String recipientId);

	@Select("SELECT LSID,recipient_id,examination_name,examination_time,examination_results,class_ranking,status FROM `learningstatus_information_donation`")
	List<LearningstatusInformationDonationEntity> getAllList();
}
